Labels:bulletin board | fence | hakham | monitor | rock | sky OCR: DATABASES 647 How does SQL specify parameters? Parameters are detailed spec- ifications for command Keywords such as WHERE usually begin an SQL clause containing the parameters for command. Suppose that Vintage Music Shop's inventory manager wants to delete all the albums in the Vintage Music Shop database recorded by Bobby Darin. The SQL looks like this: DEL ETE FROM Albums WHERE ArtistName Bobby Darin' FROM clause SQL com specifies the table WHERE clause specifies the field name mand word use and its contents Now that you've learned 1 the basic structure of an SQL query take closer look at the SQL for specific database tasks, such as adding records searching for information updating fields, organizing records and joining tables ADDING RECORDS How are records added to a database? Suppose ...
